﻿using System;

namespace Data.MySql
{
    public static class Database
    {
        // todo: change this to get the connection information from a config file

        //public static string AccessProvider = "Provider=Microsoft.ACE.OLEDB.12.0;";
        //public static string AccessSecurity = "Persist Security Info=False;";
        //public static string Password = "JET OLEDB:Database Password=MyPassword;"; // add your password if desired

        //public static string TimeSplicerProduction = @"Data Source=C:\Users\rudy__000\Documents\Data\TimeSplicer_Development.accdb;"; // use your file path
        //public static string TimeSplicerDevelopment = @"";


        public static string Server = "SERVER=127.0.0.1;"; // localhost or 127.0.0.1
        public static string DatabaseName = "DATABASE=timesplicer;";
        public static string UID = "UID=Rudy;"; // UID is case sensitive
        public static string Password = "PASSWORD=admin;"; // pass is probably case sensitive too



        // will probably database strings to config file
        public static string GetConnectionString()
        {
            //if (db == Access_Database.TimeSplicer)
            //{
            return String.Format("{0}{1}{2}{3}", Server, DatabaseName, UID, Password);
            //}

            //return String.Empty;
        }
    }
}
